'use strict';

module.exports = app => {
	const { STRING,INTEGER,DATE } = app.Sequelize;

	const SysTest = app.model.define('sys_test', {

		id: { type: STRING(36), primaryKey: true },//id 
		username: { type: STRING(50) },//用户名 
		name: { type: STRING(50) },//名称 
		age: { type: INTEGER },//年龄 
		phone: { type: STRING(11) },//联系电话 
		email: { type: STRING(50) },//邮箱 
		create_by: { type: STRING(64) },//创建者 
		create_time: { type: DATE },//创建时间 
		update_by: { type: STRING(64) },//更新者 
		update_time: { type: DATE },//更新时间 
		deleted: { type: STRING(2) },//删除标志（0代表存在 1代表删除 
	},{
	//防止查询在表名后加s
	freezeTableName:true,
	//是否自动创建create_at
	timestamps:false
	});

return SysTest;
};